CmDocMgmtSftDetail 
Logical Entity Name  CmDocMgmtSftDetail 
Default Table Name  CmDocMgmtSftDetail 
Physical Only  NO 
Definition 
 
Note 
 

CmDocMgmtSftDetail Columns 
ColumnName  Domain  Datatype  NULL  Definition 
CmDocMgmtSftDetailID(PK)    char(10)  NO 
 
Code    char(10)  NO 
 
Descrip    char(10)  NO 
 
IntegrationEnable    char(10)  NO 
 
AllCampuses    char(10)  NO 
 
SyCampusGrpID(FK)    int  YES 
 
URL    char(10)  YES 
 
CustomFolder    char(10)  YES 
 
CaptureProfile    char(10)  YES 
 
PrereqStudentCreation    char(10)  NO 
 
POSTStudentURL    char(10)  YES 
 
PrereqDocTypeCreation    char(10)  NO 
 
DocTypeURL    char(10)  YES 
 
UseInterface    char(10)  NO 
 
POSTDocumentURL    char(10)  YES 
 
PUTDocumentRenditionURL    char(10)  YES 
 
PUTDocumentRevisionURL    char(10)  YES 
 
DELETEDocumentURL    char(10)  YES 
 
Active    char(10)  NO 
 
SystemCode    char(10)  NO 
 
DateAdded    char(10)  NO 
 
DateLstMod    char(10)  NO 
 
UserID(FK)    int  NO 
 
Ts    char(10)  NO 
 
DMProvider    char(10)  YES 
 
GetDocumentTypeurl    char(10)  YES 
 

CmDocMgmtSftDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_CmDocMgmtSftDetail  PrimaryKey  CmDocMgmtSftDetailID 

CmDocMgmtSftDetail Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyCampusGrp  Non-Identifying  Zero or One to Zero or More  FK_CmDocMgmtSftDetail_SyCampusGrpID_SyCampusGrp_SyCampusGrpID      SyCampusGrpID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_CmDocMgmtSftDetail_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
CmDocMgmtConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtFiletypeConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtFiletypeConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtKeywordConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtKeywordConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtServiceAPIConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtServiceAPIConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtServiceFileTypeConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtServiceFileTypeConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtServiceKeywordConfiguration  Non-Identifying  One To Zero or More  FK_CmDocMgmtServiceKeywordConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocMgmtSftStudentCreationFields  Non-Identifying  One To Zero or More  FK_CmDocMgmtSftStudentCreationFields_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
CmDocTypeIntegratedDMServiceDetail  Non-Identifying  One To Zero or More  FK_CmDocTypeIntegratedDMServiceDetail_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
SyStudentExternalDMConfiguration  Non-Identifying  One To Zero or More  FK_SyStudentExternalDMConfiguration_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 
SyStudentExternalDMIdentifierMap  Non-Identifying  One To Zero or More  FK_SyStudentExternalDMIdentifierMap_CmDocMgmtSftDetailID_CmDocMgmtSftDetail_CmDocMgmtSftDetailID        NO  YES 

CmDocMgmtSftDetail Check Constraints 
Check Constraint Name  CheckConstraint